{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Avg Rent By Crop and Rotation","Avg Rent by Total Crop Acres"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,2,19],[3,0,3,19],[4,0,4,19],[5,0,5,19],[11,5,11,19],[10,2,10,19],[43,3,44,16],[13,7,13,9],[39,2,39,9],[33,2,34,19],[29,2,31,19],[19,2,21,19],[14,5,14,19],[16,7,16,8],[17,7,17,9],[41,2,41,19],[23,2,24,19],[37,2,37,19]]}
["Multi-Year Land Rent Value Calculator"]
[]
[]
["Template by: Jon LaPorte, Farm Business Management Educator"]
["Michigan State University Extension"]
["Email: laportej@msu.edu"]
[]
[]
[null,"Each TAB represents a different approach to determining land rent by crop and rotation.  Click on a TAB to enter specific information."]
[null,"These include:"]
[]
[null,null,"Average Rent by Crop and Rotation",null,"-","Helps to determine the average rent based on crops raised across a rotation."]
[null,null,null,null,null,"Enter:","-","Crops raised"]
[null,null,null,null,null,null,"-","Rent values by crop"]
[null,null,"Average Rent by Total Crop Acres",null,"-","Helps to determine the average rent based on crops raised and total farm acres."]
[null,null,null,null,null,"Enter:","-","Crops raised"]
[null,null,null,null,null,null,"-","Acres by crop"]
[null,null,null,null,null,null,"-","Rent values by crop"]
[null,null,"Notes:"]
[null,null,"This calculator is intended for use in designing long-term or multi-year farm rental agreements as part of a land rent negotiation process. Estimating the yearly or long-term average rent can be helpful if cash rent will be adjusted based on the crop rotation. For these scenarios, landowners and farm tenants can consider impacts to long-term rent if changes in crop rotation are required. "]
[]
[]
[]
[null,null,"Farms desiring a fixed cash rent agreement can also benefit from discussions of revenue potential with crop rotations. Designing a fixed cash rent agreement to match the farm's production plans can help achieve long-term sustainability of land access."]
[]
[]
[null,null,"Final rent negotiations are recommended to always consider landowner expenses and farmer cost of production needs, in addition to any other property access/use considerations. "]
[]
[null,null,"Production vs. Non-Production Contract Scenarios:"]
[null,null,"Production Contracts: Multiple year lease agreements can be common in areas where crops are grown under production contracts. Production contracts can provide a higher source of revenue than commercially grown crops. Adjusting cash rent values in long-term leases to account for years when higher revenue crops are grown can benefit both landowner and farm tenant. Landowners can receive a share of higher revenue generated by their property. Farm tenants can establish a long-term plan for managing rent payments. "]
[]
[]
[]
[null,null,"Non-Production Contracts: Multiple year lease agreements can also be common for non-production contract farms. Use of multi-year planning is recommended for all size operations, regardless of how crops are marketed. Landowners and farm tenants can benefit from long-term rental agreements that consider both party needs. "]
[]
[]
[null,null,"Additional Instructions:"]
[null,null,"Anything in BLUE can be edited without altering any formulas in the spreadsheet."]
[]
[null,null,"All values are auto calculated based on various formulas."]
[]
[null,null,"A \"reset\" macro button is provided to clear out example information.  All editable fields can be cleared manual for non-macro users or individuals using a mobile device."]
[]
[null,null,null,"Disclaimer: All example crops and values shown within the calculator are for demonstrative purposes only.  Examples should not be viewed as recommended rotations of crops being grown or values associated with each crop."]

{"sheet":"Avg Rent By Crop and Rotation","index":1,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,2,23,5],[16,0,19,0],[4,0,8,0],[22,2,22,5],[3,2,3,3],[3,4,3,5],[20,0,22,0],[0,2,0,13],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13]]}
[null,null,"Lease Dollar value , by crop and rotation"]
[]
[null,null,"Crop rotations and crops grown"]
[null,null,"Option 1",null,"Option 2",null,"Option 3",null,"Option 4",null,"Option 5",null,"Option 6"]
["Click on drop down list if you want to change the crop listed ------>",null,"Soybeans",{"$f":"IFERROR(VLOOKUP(C5,$C$16:$D$21,2,FALSE),0)","v":175},"Commercial Corn",{"$f":"IFERROR(VLOOKUP(E5,$C$16:$D$21,2,FALSE),0)","v":200},"Soybeans",{"$f":"IFERROR(VLOOKUP(G5,$C$16:$D$21,2,FALSE),0)","v":175},"Soybeans",{"$f":"IFERROR(VLOOKUP(I5,$C$16:$D$21,2,FALSE),0)","v":175},"Wheat",{"$f":"IFERROR(VLOOKUP(K5,$C$16:$D$21,2,FALSE),0)","v":175},"Potatoes",{"$f":"IFERROR(VLOOKUP(M5,$C$16:$D$21,2,FALSE),0)","v":300}]
[null,null,"Commercial Corn",{"$f":"IFERROR(VLOOKUP(C6,$C$16:$D$21,2,FALSE),0)","v":200},"Soybeans",175,"Seed Corn",{"$f":"IFERROR(VLOOKUP(G6,$C$16:$D$21,2,FALSE),0)","v":250},"Seed Corn",{"$f":"IFERROR(VLOOKUP(I6,$C$16:$D$21,2,FALSE),0)","v":250},"Soybeans",{"$f":"IFERROR(VLOOKUP(K6,$C$16:$D$21,2,FALSE),0)","v":175},"Seed Corn",{"$f":"IFERROR(VLOOKUP(M6,$C$16:$D$21,2,FALSE),0)","v":250}]
[null,null,"Potatoes",300,"Commercial Corn",200,"Soybeans",{"$f":"IFERROR(VLOOKUP(G7,$C$16:$D$21,2,FALSE),0)","v":175},"Potatoes",{"$f":"IFERROR(VLOOKUP(I7,$C$16:$D$21,2,FALSE),0)","v":300},"Commercial Corn",{"$f":"IFERROR(VLOOKUP(K7,$C$16:$D$21,2,FALSE),0)","v":200},"Soybeans",{"$f":"IFERROR(VLOOKUP(M7,$C$16:$D$21,2,FALSE),0)","v":175}]
[null,null,"Seed Corn",250,"Soybeans",175,"Seed Corn",{"$f":"IFERROR(VLOOKUP(G8,$C$16:$D$21,2,FALSE),0)","v":250},"Seed Corn",{"$f":"IFERROR(VLOOKUP(I8,$C$16:$D$21,2,FALSE),0)","v":250},"Soybeans",{"$f":"IFERROR(VLOOKUP(K8,$C$16:$D$21,2,FALSE),0)","v":175},"Wheat",{"$f":"IFERROR(VLOOKUP(M8,$C$16:$D$21,2,FALSE),0)","v":175}]
[null,null,"None",0,"None",0,"None",{"$f":"IFERROR(VLOOKUP(G9,$C$16:$D$21,2,FALSE),0)","v":0},"Seed Corn",{"$f":"IFERROR(VLOOKUP(I9,$C$16:$D$21,2,FALSE),0)","v":250},"Wheat",{"$f":"IFERROR(VLOOKUP(K9,$C$16:$D$21,2,FALSE),0)","v":175},"Potatoes",{"$f":"IFERROR(VLOOKUP(M9,$C$16:$D$21,2,FALSE),0)","v":300}]
[null,null,"Averge Rent/Acre",{"$f":"IFERROR(AVERAGEIF(D5:D9,\"<>0\"),0)","v":231.25},"Averge Rent/Acre",{"$f":"IFERROR(AVERAGEIF(F5:F9,\"<>0\"),0)","v":187.5},"Averge Rent/Acre",{"$f":"IFERROR(AVERAGEIF(H5:H9,\"<>0\"),0)","v":212.5},"Averge Rent/Acre",{"$f":"IFERROR(AVERAGEIF(J5:J9,\"<>0\"),0)","v":245},"Averge Rent/Acre",{"$f":"IFERROR(AVERAGEIF(L5:L9,\"<>0\"),0)","v":180},"Averge Rent/Acre",{"$f":"IFERROR(AVERAGEIF(N5:N9,\"<>0\"),0)","v":240}]
[]
[]
[]
[]
[null,null,"Crop grown","Rent Values"]
[null,null,"None",0]
["Edit crops grown and rent values if those change ------>",null,"Commercial Corn",200]
[null,null,"Soybeans",175]
[null,null,"Seed Corn",250]
[null,null,"Potatoes",300]
["Note: Editing crops changes drop down list options",null,"Wheat",175]
[]
[null,null,"Anything in BLUE can be edited without altering any formulas in the spreadsheet"]
[null,null,"All values are auto calculated based on various formulas"]

{"sheet":"Avg Rent by Total Crop Acres","index":2,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[9,9,10,9],[9,10,10,10],[3,10,4,10],[5,9,6,9],[5,10,6,10],[7,9,8,9],[7,10,8,10],[0,3,0,10],[27,3,27,6],[28,3,28,6],[21,0,22,1],[5,0,6,0],[8,0,8,1],[5,3,6,3],[7,3,8,3],[9,3,10,3],[11,3,12,3],[13,3,14,3],[23,0,24,0],[11,9,12,9],[11,10,12,10],[13,9,14,9],[13,10,14,10]]}
[null,null,null,"Lease Dollar value , by crop and rotation"]
[]
[null,null,null,"Crop rotations and crops grown"]
[null,null,null,null,"Total Acres","Total Acres","Total Acres","Total Acres","Total Acres","Total","Avg Rent"]
["Edit acres ------>",null,null,"Year/acres",200,180,220,100,200,{"$f":"SUM(E5:I5)","v":900}]
["Click on drop down list to change crop listed ------>",null,null,2025,"Commercial Corn","Soybeans","Commercial Corn","Potatoes","Seed Corn",{"$f":"SUM(E7:I7)","v":195500},{"$f":"IFERROR(J6/$J$5,0)","v":217.22222222222223}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(E6,$D$21:$E$26,2,FALSE)*E$5,0)","v":40000},{"$f":"IFERROR(VLOOKUP(F6,$D$21:$E$26,2,FALSE)*F$5,0)","v":31500},{"$f":"IFERROR(VLOOKUP(G6,$D$21:$E$26,2,FALSE)*G$5,0)","v":44000},30000,50000]
["Edit Years ------>",null,null,2026,"Soybeans","Wheat","Potatoes","Seed Corn","Soybeans",{"$f":"SUM(E9:I9)","v":192500},{"$f":"IFERROR(J8/$J$5,0)","v":213.88888888888889}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(E8,$D$21:$E$26,2,FALSE)*E$5,0)","v":35000},{"$f":"IFERROR(VLOOKUP(F8,$D$21:$E$26,2,FALSE)*F$5,0)","v":31500},{"$f":"IFERROR(VLOOKUP(G8,$D$21:$E$26,2,FALSE)*G$5,0)","v":66000},25000,{"$f":"IFERROR(VLOOKUP(I8,$D$21:$E$26,2,FALSE)*I$5,0)","v":35000}]
[null,null,null,2027,"Commercial Corn","Soybeans","Commercial Corn","Soybeans","Wheat",{"$f":"SUM(E11:I11)","v":168000},{"$f":"IFERROR(J10/$J$5,0)","v":186.66666666666666}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(E10,$D$21:$E$26,2,FALSE)*E$5,0)","v":40000},{"$f":"IFERROR(VLOOKUP(F10,$D$21:$E$26,2,FALSE)*F$5,0)","v":31500},{"$f":"IFERROR(VLOOKUP(G10,$D$21:$E$26,2,FALSE)*G$5,0)","v":44000},{"$f":"IFERROR(VLOOKUP(H10,$D$21:$E$26,2,FALSE)*H$5,0)","v":17500},{"$f":"IFERROR(VLOOKUP(I10,$D$21:$E$26,2,FALSE)*I$5,0)","v":35000}]
[null,null,null,2028,"Wheat","Potatoes","Commercial Corn","Soybeans","Potatoes",{"$f":"SUM(E13:I13)","v":210500},{"$f":"IFERROR(J12/$J$5,0)","v":233.88888888888889}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(E12,$D$21:$E$26,2,FALSE)*E$5,0)","v":35000},{"$f":"IFERROR(VLOOKUP(F12,$D$21:$E$26,2,FALSE)*F$5,0)","v":54000},{"$f":"IFERROR(VLOOKUP(G12,$D$21:$E$26,2,FALSE)*G$5,0)","v":44000},{"$f":"IFERROR(VLOOKUP(H12,$D$21:$E$26,2,FALSE)*H$5,0)","v":17500},{"$f":"IFERROR(VLOOKUP(I12,$D$21:$E$26,2,FALSE)*I$5,0)","v":60000}]
[null,null,null,2029,"Potatoes","Commercial Corn","Soybeans","Wheat","Commercial Corn",{"$f":"SUM(E15:I15)","v":192000},{"$f":"IFERROR(J14/$J$5,0)","v":213.33333333333334}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(E14,$D$21:$E$26,2,FALSE)*E$5,0)","v":60000},{"$f":"IFERROR(VLOOKUP(F14,$D$21:$E$26,2,FALSE)*F$5,0)","v":36000},{"$f":"IFERROR(VLOOKUP(G14,$D$21:$E$26,2,FALSE)*G$5,0)","v":38500},{"$f":"IFERROR(VLOOKUP(H14,$D$21:$E$26,2,FALSE)*H$5,0)","v":17500},{"$f":"IFERROR(VLOOKUP(I14,$D$21:$E$26,2,FALSE)*I$5,0)","v":40000}]
[]
[]
[]
[]
[null,null,null,"Crop grown","Rent Values"]
[null,null,null,"None",0]
["Edit crops grown and rent values ------>",null,null,"Commercial Corn",200]
[null,null,null,"Soybeans",175]
["Note: Editing crops changes drop down list options",null,null,"Seed Corn",250]
[null,null,null,"Potatoes",300]
[null,null,null,"Wheat",175]
[]
[null,null,null,"Anything in BLUE can be edited without altering any formulas in the spreadsheet"]
[null,null,null,"All values are auto calculated based on various formulas"]